{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "e8deeb66",
   "metadata": {},
   "source": [
    "### 环境准备"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6dab39b2",
   "metadata": {},
   "source": [
    "- 魔术函数设置matplotlib样式\n",
    "- 导入pandas库和matplotlib库\n",
    "- 设置matplotlib字体"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "83c09813",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "94d5c192",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b097f3a7",
   "metadata": {},
   "outputs": [],
   "source": [
    "plt.rcParams['font.sans-serif'] = ['SimHei']\n",
    "plt.rcParams['axes.unicode_minus'] = False"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "97d9146b",
   "metadata": {},
   "source": [
    "### 数据采集"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4688ed2c",
   "metadata": {},
   "source": [
    "- 读取报表1和报表2\n",
    "- 查看数据\n",
    "- 根据编号列合并两个报表\n",
    "- 查看合并后的数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5f6c510f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1b25d6f4",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "acc149ac",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1450f27a",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ff961400",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "f24abc55",
   "metadata": {},
   "source": [
    "### 数据处理"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "644c59d7",
   "metadata": {},
   "source": [
    "- 将编号设置为索引\n",
    "- 查看data的详细信息"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1387a26c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c69dc8cb",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "2b047359",
   "metadata": {},
   "source": [
    "- 修改列名：销售额\n",
    "- 规范化销售量和销售额数据类型为: int64"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "956e078d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2d8e048f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0d72835b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "bc2a818e",
   "metadata": {},
   "source": [
    "- 将细分市场一列全部设置为大写"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d4944775",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "58ffb476",
   "metadata": {},
   "source": [
    "- 产品Montana已经停产，请将其从数据中移除"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "508a8c63",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2b63ccfd",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "e82ca576",
   "metadata": {},
   "source": [
    "### 数据分析与可视化"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6dc4af2b",
   "metadata": {},
   "source": [
    "- 查看销售额靠前的数据\n",
    "    - 数据排序\n",
    "    - 数据查看"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2582b2d2",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ed4e8189",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "f3dcb2e4",
   "metadata": {},
   "source": [
    "- 查看利润最高的日期\n",
    "    - 对数据按日期进行排序\n",
    "    - 按日期汇总利润\n",
    "    - 对汇总利润进行排序\n",
    "    - 可视化分析"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cf959fed",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "efeb5f38",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f7271044",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "15af2eef",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "17faf2c8",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "f24d8fb6",
   "metadata": {},
   "source": [
    "- 对每月收益进行可视化分析"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ec52c038",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "f38bbfe2",
   "metadata": {},
   "source": [
    "- 查看利润最高的国家/地区\n",
    "    - 按国家对数据进行分组\n",
    "    - 按国家汇总利润\n",
    "    - 按汇总利润进行排序\n",
    "    - 利用饼图进行可视化分析"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c12ac878",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "86f812e9",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e43401ec",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "18bb7dcf",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "4a6d6275",
   "metadata": {},
   "source": [
    "- 产品和细分市场投资决策分析\n",
    "    - 按产品和细分市场查看**销售额**数据\n",
    "    - 按产品和细分市场进行分组汇总\n",
    "    - 查看数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d2d6410e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "af61161d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "914b2705",
   "metadata": {},
   "source": [
    "- 使用unstack进行数据重塑\n",
    "- unstack: 将行透视为列"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "47900937",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "c407813c",
   "metadata": {},
   "source": [
    "- 取不同市场的销售额数据\n",
    "- 可视化分析"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c58b6c19",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "85784446",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
